You are here: Inventory > Defining Inventory Forms > Inventory Maintenance > Debtor Specific Prices

Debtor Specific Prices

Allows a price to be set up by debtor. These debtor specific prices can be added, updated and deleted as required. This grid can also be sorted per grid column.

Field Description
Debtor Debtor account number and name are selected from the search window. This field has drill down enabled to view further debtor details
Use Qty Break Tick this field if a quantity break is required for the debtor specific price and enter in the relevant quantity
Quantity Break This field is only enabled if the Qty Break field is ticked. The user must enter the quantity break for each selected debtor. This quantity can be amended at any point
Source This field determines the pricing source for each debtor. The options available for selection include sell price, last cost, RRP or P1-P10 including future (P1 to P10)
Mode The mode determines how the debtor specific price is calculated. The debtor specific price can be set up by:
  • Percentage - a percentage value is entered and this amount is calculated from the source price selected e.g. -2.50 will be 2.5% off the select source price
  • Actual - a dollar value added or subtracted from the selected source price
  • None - means that the amount entered in the 'amount' field is the new price
Amount The figure entered in this field calculates the new price dependent on the source and mode fields e.g. if the source is 'sell price' and the mode is 'percentage' the amount entered is the percentage to which the new price relates. This then calculates the new price accordingly
New Price The new price is calculated from the previous variables. This field is the actual debtor specific price to be used for the item
Start Date Automatically prompts the current login date and can be amended if required
End Date Automatically prompts 20 years from login date and can be amended if required

Bulk insert, update and deletion of Debtor Specific Prices is done by the Debtor / Debtor Class Batch form and bulk insertion of prices by the Debtor Class Entry form.

Copyright © 2012 Jiwa Financials. All rights reserved.